package com.yalu.util;

import java.util.ArrayList;
import java.util.List;

import com.yalu.common.Constant;

import core.report.yearReport.bean.MergedBean;

public class ReportHeaderUtil {

	public final static String SHEET_NAME_WEEK = "销售分析报表(本周)-不含销退";
	public final static String SHEET_NAME_MONTH = "销售分析-本月（不含销退）";
	public final static String SHEET_NAME_YEAR = "销售分析-全年（不含销退）";

	public final static String SHEET_NAME_LAST_WEEK = " 销售分析报表(对比上周)";
	public final static String SHEET_NAME_LAST_YEAR_THIS_WEEK = "销售分析报表(对比去年本周)";
	public final static String SHEET_NAME_LAST_MONTH = "销售分析报表(对比上月)";
	public final static String SHEET_NAME_LAST_YEAR_THIS_MONTH = "销售分析报表(对比去年本月)";
	public final static String SHEET_NAME_LAST_YEAR = "销售分析报表(对比去年)";

	public final static String SHEET_NAME_LAST_YEAR_THIS_CUSTOM = "自定义时间-销售分析报表";

	public final static String SHEET_NAME_NETWORKIO = "流量分析-分平台自营店";
	public final static String SHEET_NAME_BRAND = "品牌分析";
	public final static String SHEET_NAME_PRODUCT_YEAR = "货品年份分析";
	public final static String SHEET_NAME_ITEM_SALE_RANK = "销售分析-货号销售排名";

	public final static int COL_COUNT_WEEK = 12;
	public final static int COL_COUNT_MONTH = 12;
	public final static int COL_COUNT_YEAR = 12;
	public final static int COL_COUNT_LAST_MONTH = 25;
	public final static int COL_COUNT_LAST_YEAR_THIS_MONTH = 25;
	public final static int COL_COUNT_LAST_YEAR = 25;
	public final static int COL_COUNT_LAST_WEEK = 25;
	public final static int COL_COUNT_LAST_YEAR_THIS_WEEK = 25;
	public final static int COL_COUNT_LAST_YEAR_THIS_CUSTOM = 22;
	public final static int COL_COUNT_NETWORKIO = 11;
	public final static int COL_COUNT_BRAND = 11;
	public final static int COL_COUNT_PRODUCT_YEAR = 16;
	public final static int COL_COUNT_ITEM_SALE_RANK = 11;

	public static int getColCountByDateType(String dateType) {
		if (dateType.equals(Constant.WEEK_STRING)) {
			return ReportHeaderUtil.COL_COUNT_WEEK;
		} else if (dateType.equals(Constant.MONTH_STRING)) {
			return ReportHeaderUtil.COL_COUNT_MONTH;
		} else if (dateType.equals(Constant.YEAR_STRING)) {
			return ReportHeaderUtil.COL_COUNT_YEAR;
		} else if (dateType.equals(Constant.LAST_WEEK_STRING)) {
			return ReportHeaderUtil.COL_COUNT_LAST_WEEK;
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_WEEK_STRING)) {
			return ReportHeaderUtil.COL_COUNT_LAST_YEAR_THIS_WEEK;
		} else if (dateType.equals(Constant.LAST_MONTH_STRING)) {
			return ReportHeaderUtil.COL_COUNT_LAST_MONTH;
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_MONTH_STRING)) {
			return ReportHeaderUtil.COL_COUNT_LAST_YEAR_THIS_MONTH;
		} else if (dateType.equals(Constant.LAST_YEAR_STRING)) {
			return ReportHeaderUtil.COL_COUNT_LAST_YEAR;
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_CUSTOM_STRING)) {
			return ReportHeaderUtil.COL_COUNT_LAST_YEAR_THIS_CUSTOM;
		} else if (dateType.equals(Constant.NETWORKIO_STRING)) {
			return ReportHeaderUtil.COL_COUNT_NETWORKIO;
		} else if (dateType.equals(Constant.BRAND_STRING)) {
			return ReportHeaderUtil.COL_COUNT_BRAND;
		}else if (dateType.equals(Constant.PRODUCT_YEAR_STRING)) {
			return ReportHeaderUtil.COL_COUNT_PRODUCT_YEAR;
		}else if (dateType.equals(Constant.ITEM_SALE_RANK_STRING)) {
			return ReportHeaderUtil.COL_COUNT_ITEM_SALE_RANK;
		}
		return -1;
	}

	public static String getSheetNameByDateType(String dateType) {
		if (dateType.equals(Constant.WEEK_STRING)) {
			return SHEET_NAME_WEEK;
		} else if (dateType.equals(Constant.MONTH_STRING)) {
			return SHEET_NAME_MONTH;
		} else if (dateType.equals(Constant.YEAR_STRING)) {
			return SHEET_NAME_YEAR;
		} else if (dateType.equals(Constant.LAST_WEEK_STRING)) {
			return SHEET_NAME_LAST_WEEK;
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_WEEK_STRING)) {
			return SHEET_NAME_LAST_YEAR_THIS_WEEK;
		} else if (dateType.equals(Constant.LAST_MONTH_STRING)) {
			return SHEET_NAME_LAST_MONTH;
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_MONTH_STRING)) {
			return SHEET_NAME_LAST_YEAR_THIS_MONTH;
		} else if (dateType.equals(Constant.LAST_YEAR_STRING)) {
			return SHEET_NAME_LAST_YEAR;
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_CUSTOM_STRING)) {
			return SHEET_NAME_LAST_YEAR_THIS_CUSTOM;
		} else if (dateType.equals(Constant.NETWORKIO_STRING)) {
			return SHEET_NAME_NETWORKIO;
		} else if (dateType.equals(Constant.BRAND_STRING)) {
			return SHEET_NAME_BRAND;
		}else if (dateType.equals(Constant.PRODUCT_YEAR_STRING)) {
			return SHEET_NAME_PRODUCT_YEAR;
		}else if (dateType.equals(Constant.ITEM_SALE_RANK_STRING)) {
			return SHEET_NAME_ITEM_SALE_RANK;
		}
		return "";
	}

	public static List<MergedBean> getHeaders(String dateType,
			String beginTime, String endTime, String compareYear) {
		List<MergedBean> headers = new ArrayList<MergedBean>();
		if (dateType.equals(Constant.WEEK_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 11, SHEET_NAME_WEEK));
			headers.add(new MergedBean(1, 2, 0, 0, "店铺"));
			String title = "本周" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 11, title));
			headers.add(new MergedBean(2, 2, 1, 1, "销售金额"));
			headers.add(new MergedBean(2, 2, 2, 2, "销售达成"));
			headers.add(new MergedBean(2, 2, 3, 3, "店销售占比"));
			headers.add(new MergedBean(2, 2, 4, 4, "毛利金额"));
			headers.add(new MergedBean(2, 2, 5, 5, "毛利率"));
			headers.add(new MergedBean(2, 2, 6, 6, "成本达成"));
			headers.add(new MergedBean(2, 2, 7, 7, "浏览量"));
			headers.add(new MergedBean(2, 2, 8, 8, "访客数"));
			headers.add(new MergedBean(2, 2, 9, 9, "转化率"));
			headers.add(new MergedBean(2, 2, 10, 10, "人均成交件数"));
			headers.add(new MergedBean(2, 2, 11, 11, "客单价"));

		} else if (dateType.equals(Constant.MONTH_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 11, SHEET_NAME_MONTH));
			headers.add(new MergedBean(1, 2, 0, 0, "店铺"));
			String title = "本月" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 11, title));
			headers.add(new MergedBean(2, 2, 1, 1, "销售金额"));
			headers.add(new MergedBean(2, 2, 2, 2, "销售达成"));
			headers.add(new MergedBean(2, 2, 3, 3, "销售占比"));
			headers.add(new MergedBean(2, 2, 4, 4, "毛利金额"));
			headers.add(new MergedBean(2, 2, 5, 5, "毛利率"));
			headers.add(new MergedBean(2, 2, 6, 6, "成本达成"));
			headers.add(new MergedBean(2, 2, 7, 7, "浏览量"));
			headers.add(new MergedBean(2, 2, 8, 8, "访客数"));
			headers.add(new MergedBean(2, 2, 9, 9, "转化率"));
			headers.add(new MergedBean(2, 2, 10, 10, "每单件数"));
			headers.add(new MergedBean(2, 2, 11, 11, "每单金额"));
		} else if (dateType.equals(Constant.YEAR_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 11, SHEET_NAME_YEAR));
			headers.add(new MergedBean(1, 2, 0, 0, "店铺"));
			String title = "本年" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 11, title));
			headers.add(new MergedBean(2, 2, 1, 1, "销售金额"));
			headers.add(new MergedBean(2, 2, 2, 2, "销售达成"));
			headers.add(new MergedBean(2, 2, 3, 3, "销售占比"));
			headers.add(new MergedBean(2, 2, 4, 4, "毛利金额"));
			headers.add(new MergedBean(2, 2, 5, 5, "毛利率"));
			headers.add(new MergedBean(2, 2, 6, 6, "成本达成"));
			headers.add(new MergedBean(2, 2, 7, 7, "浏览量"));
			headers.add(new MergedBean(2, 2, 8, 8, "访客数"));
			headers.add(new MergedBean(2, 2, 9, 9, "转化率"));
			headers.add(new MergedBean(2, 2, 10, 10, "每单件数"));
			headers.add(new MergedBean(2, 2, 11, 11, "每单金额"));
		} else if (dateType.equals(Constant.LAST_MONTH_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 24, SHEET_NAME_LAST_MONTH));
			headers.add(new MergedBean(1, 3, 0, 0, "店铺"));

			String title = "对比上月" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 24, title));

			headers.add(new MergedBean(2, 2, 1, 3, "销售金额%"));
			headers.add(new MergedBean(2, 2, 4, 6, "毛利金额%"));
			headers.add(new MergedBean(2, 2, 7, 9, "成本达成%	"));
			headers.add(new MergedBean(2, 2, 10, 12, "浏览量%"));
			headers.add(new MergedBean(2, 2, 13, 15, "访客数%"));
			headers.add(new MergedBean(2, 2, 16, 18, "转化率%"));
			headers.add(new MergedBean(2, 2, 19, 21, "每单件数%"));
			headers.add(new MergedBean(2, 2, 22, 24, "每单金额%"));

			headers.add(new MergedBean(3, 3, 1, 1, "上月金额"));
			headers.add(new MergedBean(3, 3, 2, 2, "金额"));
			headers.add(new MergedBean(3, 3, 3, 3, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 4, 4, "上月金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 7, 7, "上月成本达成"));
			headers.add(new MergedBean(3, 3, 8, 8, "成本达成"));
			headers.add(new MergedBean(3, 3, 9, 9, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 10, 10, "上月浏览量"));
			headers.add(new MergedBean(3, 3, 11, 11, "浏览量"));
			headers.add(new MergedBean(3, 3, 12, 12, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 13, 13, "上月访客数"));
			headers.add(new MergedBean(3, 3, 14, 14, "访客数"));
			headers.add(new MergedBean(3, 3, 15, 15, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 16, 16, "上月转化率"));
			headers.add(new MergedBean(3, 3, 17, 17, "转化率"));
			headers.add(new MergedBean(3, 3, 18, 18, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 19, 19, "上月每单件数"));
			headers.add(new MergedBean(3, 3, 20, 20, "每单件数"));
			headers.add(new MergedBean(3, 3, 21, 21, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 22, 22, "上月每单金额"));
			headers.add(new MergedBean(3, 3, 23, 23, "每单金额"));
			headers.add(new MergedBean(3, 3, 24, 24, "增长率(%)"));
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_MONTH_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 24,
					SHEET_NAME_LAST_YEAR_THIS_MONTH));
			headers.add(new MergedBean(1, 3, 0, 0, "店铺"));

			String title = "对比去年本月" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 24, title));

			headers.add(new MergedBean(2, 2, 1, 3, "销售金额%"));
			headers.add(new MergedBean(2, 2, 4, 6, "毛利金额%"));
			headers.add(new MergedBean(2, 2, 7, 9, "成本达成%	"));
			headers.add(new MergedBean(2, 2, 10, 12, "浏览量%"));
			headers.add(new MergedBean(2, 2, 13, 15, "访客数%"));
			headers.add(new MergedBean(2, 2, 16, 18, "转化率%"));
			headers.add(new MergedBean(2, 2, 19, 21, "每单件数%"));
			headers.add(new MergedBean(2, 2, 22, 24, "每单金额%"));

			headers.add(new MergedBean(3, 3, 1, 1, "去年金额"));
			headers.add(new MergedBean(3, 3, 2, 2, "金额"));
			headers.add(new MergedBean(3, 3, 3, 3, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 4, 4, "去年金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 7, 7, "去年成本达成"));
			headers.add(new MergedBean(3, 3, 8, 8, "成本达成"));
			headers.add(new MergedBean(3, 3, 9, 9, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 10, 10, "去年浏览量"));
			headers.add(new MergedBean(3, 3, 11, 11, "浏览量"));
			headers.add(new MergedBean(3, 3, 12, 12, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 13, 13, "去年访客数"));
			headers.add(new MergedBean(3, 3, 14, 14, "访客数"));
			headers.add(new MergedBean(3, 3, 15, 15, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 16, 16, "去年转化率"));
			headers.add(new MergedBean(3, 3, 17, 17, "转化率"));
			headers.add(new MergedBean(3, 3, 18, 18, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 19, 19, "去年每单件数"));
			headers.add(new MergedBean(3, 3, 20, 20, "每单件数"));
			headers.add(new MergedBean(3, 3, 21, 21, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 22, 22, "去年每单金额"));
			headers.add(new MergedBean(3, 3, 23, 23, "每单金额"));
			headers.add(new MergedBean(3, 3, 24, 24, "增长率(%)"));
		} else if (dateType.equals(Constant.LAST_YEAR_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 24, SHEET_NAME_LAST_YEAR));
			headers.add(new MergedBean(1, 3, 0, 0, "店铺"));

			String title = "对比去年" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 24, title));

			headers.add(new MergedBean(2, 2, 1, 3, "销售金额%"));
			headers.add(new MergedBean(2, 2, 4, 6, "毛利金额%"));
			headers.add(new MergedBean(2, 2, 7, 9, "成本达成%	"));
			headers.add(new MergedBean(2, 2, 10, 12, "浏览量%"));
			headers.add(new MergedBean(2, 2, 13, 15, "访客数%"));
			headers.add(new MergedBean(2, 2, 16, 18, "转化率%"));
			headers.add(new MergedBean(2, 2, 19, 21, "每单件数%"));
			headers.add(new MergedBean(2, 2, 22, 24, "每单金额%"));

			headers.add(new MergedBean(3, 3, 1, 1, "去年金额"));
			headers.add(new MergedBean(3, 3, 2, 2, "金额"));
			headers.add(new MergedBean(3, 3, 3, 3, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 4, 4, "去年金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 7, 7, "去年成本达成"));
			headers.add(new MergedBean(3, 3, 8, 8, "成本达成"));
			headers.add(new MergedBean(3, 3, 9, 9, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 10, 10, "去年浏览量"));
			headers.add(new MergedBean(3, 3, 11, 11, "浏览量"));
			headers.add(new MergedBean(3, 3, 12, 12, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 13, 13, "去年访客数"));
			headers.add(new MergedBean(3, 3, 14, 14, "访客数"));
			headers.add(new MergedBean(3, 3, 15, 15, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 16, 16, "去年转化率"));
			headers.add(new MergedBean(3, 3, 17, 17, "转化率"));
			headers.add(new MergedBean(3, 3, 18, 18, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 19, 19, "去年每单件数"));
			headers.add(new MergedBean(3, 3, 20, 20, "每单件数"));
			headers.add(new MergedBean(3, 3, 21, 21, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 22, 22, "去年每单金额"));
			headers.add(new MergedBean(3, 3, 23, 23, "每单金额"));
			headers.add(new MergedBean(3, 3, 24, 24, "增长率(%)"));
		} else if (dateType.equals(Constant.LAST_WEEK_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 24, SHEET_NAME_LAST_WEEK));
			headers.add(new MergedBean(1, 3, 0, 0, "店铺"));

			String title = "对比同年上周" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 24, title));

			headers.add(new MergedBean(2, 2, 1, 3, "销售金额%"));
			headers.add(new MergedBean(2, 2, 4, 6, "毛利金额%"));
			headers.add(new MergedBean(2, 2, 7, 9, "成本达成%	"));
			headers.add(new MergedBean(2, 2, 10, 12, "浏览量%"));
			headers.add(new MergedBean(2, 2, 13, 15, "访客数%"));
			headers.add(new MergedBean(2, 2, 16, 18, "转化率%"));
			headers.add(new MergedBean(2, 2, 19, 21, "每单件数%"));
			headers.add(new MergedBean(2, 2, 22, 24, "每单金额%"));

			headers.add(new MergedBean(3, 3, 1, 1, "上周金额"));
			headers.add(new MergedBean(3, 3, 2, 2, "金额"));
			headers.add(new MergedBean(3, 3, 3, 3, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 4, 4, "上周金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 7, 7, "上周成本达成"));
			headers.add(new MergedBean(3, 3, 8, 8, "成本达成"));
			headers.add(new MergedBean(3, 3, 9, 9, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 10, 10, "上周浏览量"));
			headers.add(new MergedBean(3, 3, 11, 11, "浏览量"));
			headers.add(new MergedBean(3, 3, 12, 12, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 13, 13, "上周访客数"));
			headers.add(new MergedBean(3, 3, 14, 14, "访客数"));
			headers.add(new MergedBean(3, 3, 15, 15, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 16, 16, "上周转化率"));
			headers.add(new MergedBean(3, 3, 17, 17, "转化率"));
			headers.add(new MergedBean(3, 3, 18, 18, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 19, 19, "上周每单件数"));
			headers.add(new MergedBean(3, 3, 20, 20, "每单件数"));
			headers.add(new MergedBean(3, 3, 21, 21, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 22, 22, "上周每单金额"));
			headers.add(new MergedBean(3, 3, 23, 23, "每单金额"));
			headers.add(new MergedBean(3, 3, 24, 24, "增长率(%)"));
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_WEEK_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 24,
					SHEET_NAME_LAST_YEAR_THIS_WEEK));
			headers.add(new MergedBean(1, 3, 0, 0, "店铺"));

			String title = "销售分析- 对比去年本周(不含销退)" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 24, title));

			headers.add(new MergedBean(2, 2, 1, 3, "销售金额%"));
			headers.add(new MergedBean(2, 2, 4, 6, "毛利金额%"));
			headers.add(new MergedBean(2, 2, 7, 9, "成本达成%	"));
			headers.add(new MergedBean(2, 2, 10, 12, "浏览量%"));
			headers.add(new MergedBean(2, 2, 13, 15, "访客数%"));
			headers.add(new MergedBean(2, 2, 16, 18, "转化率%"));
			headers.add(new MergedBean(2, 2, 19, 21, "每单件数%"));
			headers.add(new MergedBean(2, 2, 22, 24, "每单金额%"));

			headers.add(new MergedBean(3, 3, 1, 1, "去年金额"));
			headers.add(new MergedBean(3, 3, 2, 2, "金额"));
			headers.add(new MergedBean(3, 3, 3, 3, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 4, 4, "去年金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 7, 7, "去年成本达成"));
			headers.add(new MergedBean(3, 3, 8, 8, "成本达成"));
			headers.add(new MergedBean(3, 3, 9, 9, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 10, 10, "去年浏览量"));
			headers.add(new MergedBean(3, 3, 11, 11, "浏览量"));
			headers.add(new MergedBean(3, 3, 12, 12, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 13, 13, "去年访客数"));
			headers.add(new MergedBean(3, 3, 14, 14, "访客数"));
			headers.add(new MergedBean(3, 3, 15, 15, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 16, 16, "去年转化率"));
			headers.add(new MergedBean(3, 3, 17, 17, "转化率"));
			headers.add(new MergedBean(3, 3, 18, 18, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 19, 19, "去年每单件数"));
			headers.add(new MergedBean(3, 3, 20, 20, "每单件数"));
			headers.add(new MergedBean(3, 3, 21, 21, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 22, 22, "去年每单金额"));
			headers.add(new MergedBean(3, 3, 23, 23, "每单金额"));
			headers.add(new MergedBean(3, 3, 24, 24, "增长率(%)"));
		} else if (dateType.equals(Constant.LAST_YEAR_THIS_CUSTOM_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 21,
					SHEET_NAME_LAST_YEAR_THIS_CUSTOM));
			headers.add(new MergedBean(1, 3, 0, 0, "店铺"));

			String title = "销售分析报表(对比年份" + compareYear + ")" + beginTime;
			headers.add(new MergedBean(1, 1, 1, 21, title));

			headers.add(new MergedBean(2, 2, 1, 3, "销售金额%"));
			headers.add(new MergedBean(2, 2, 4, 6, "毛利金额%"));
			headers.add(new MergedBean(2, 2, 7, 9, "浏览量%	"));
			headers.add(new MergedBean(2, 2, 10, 12, "访客数%"));
			headers.add(new MergedBean(2, 2, 13, 15, "转化率%"));
			headers.add(new MergedBean(2, 2, 16, 18, "每单件数%"));
			headers.add(new MergedBean(2, 2, 19, 21, "每单金额%"));

			headers.add(new MergedBean(3, 3, 1, 1, "对比金额"));
			headers.add(new MergedBean(3, 3, 2, 2, "金额"));
			headers.add(new MergedBean(3, 3, 3, 3, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 4, 4, "对比金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 7, 7, "对比浏览量"));
			headers.add(new MergedBean(3, 3, 8, 8, "浏览量"));
			headers.add(new MergedBean(3, 3, 9, 9, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 10, 10, "对比访客数"));
			headers.add(new MergedBean(3, 3, 11, 11, "访客数"));
			headers.add(new MergedBean(3, 3, 12, 12, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 13, 13, "对比转化率"));
			headers.add(new MergedBean(3, 3, 14, 14, "转化率"));
			headers.add(new MergedBean(3, 3, 15, 15, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 16, 16, "对比每单件数"));
			headers.add(new MergedBean(3, 3, 17, 17, "每单件数"));
			headers.add(new MergedBean(3, 3, 18, 18, "增长率(%)"));
			headers.add(new MergedBean(3, 3, 19, 19, "对比每单金额"));
			headers.add(new MergedBean(3, 3, 20, 20, "每单金额"));
			headers.add(new MergedBean(3, 3, 21, 21, "增长率(%)"));
		} else if (dateType.equals(Constant.NETWORKIO_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 10, SHEET_NAME_NETWORKIO
					+ beginTime));
			headers.add(new MergedBean(1, 2, 0, 0, "店铺"));

			headers.add(new MergedBean(1, 1, 1, 6, "本周"));
			headers.add(new MergedBean(1, 1, 7, 8, "对比上周（%）"));
			headers.add(new MergedBean(1, 1, 9, 10, "资源位置"));

			headers.add(new MergedBean(2, 2, 1, 1, "浏览量"));
			headers.add(new MergedBean(2, 2, 2, 2, "浏览量占比"));
			headers.add(new MergedBean(2, 2, 3, 3, "访客数"));
			headers.add(new MergedBean(2, 2, 4, 4, "访客数占比"));
			headers.add(new MergedBean(2, 2, 5, 5, "免费流量"));
			headers.add(new MergedBean(2, 2, 6, 6, "免费占比"));
			headers.add(new MergedBean(2, 2, 7, 7, "浏览量"));
			headers.add(new MergedBean(2, 2, 8, 8, "访客数"));
			headers.add(new MergedBean(2, 2, 9, 9, "本周资源位置"));
			headers.add(new MergedBean(2, 2, 10, 10, "下周资源位置"));
		} else if (dateType.equals(Constant.BRAND_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 10, SHEET_NAME_BRAND));
			headers.add(new MergedBean(1, 2, 0, 0, "品牌"));

			headers.add(new MergedBean(1, 1, 1, 10, ReportExportUtil.formatTime("yyyyMMdd", "dd/MM/yyyy", beginTime) +"--"+ReportExportUtil.formatTime("yyyyMMdd", "dd/MM/yyyy", endTime) ));
			headers.add(new MergedBean(2, 2, 1, 1, "销售件数"));
			headers.add(new MergedBean(2, 2, 2, 2, "每件单价"));
			headers.add(new MergedBean(2, 2, 3, 3, "销售金额"));
			headers.add(new MergedBean(2, 2, 4, 4, "品牌销售占比"));
			headers.add(new MergedBean(2, 2, 5, 5, "毛利金额"));
			headers.add(new MergedBean(2, 2, 6, 6, "毛利占比"));
			headers.add(new MergedBean(2, 2, 7, 7, "成本达成"));
			headers.add(new MergedBean(2, 2, 8, 8, "库存占比"));
			headers.add(new MergedBean(2, 2, 9, 9, "每单件数"));
			headers.add(new MergedBean(2, 2, 10, 10, "每单金额"));
		}else if (dateType.equals(Constant.PRODUCT_YEAR_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 15, SHEET_NAME_PRODUCT_YEAR));
			headers.add(new MergedBean(1, 3, 0, 0, "货号"));

			headers.add(new MergedBean(1, 1, 1, 15, ReportExportUtil.formatTime("yyyyMMdd", "dd/MM/yyyy", beginTime) +"--"+ReportExportUtil.formatTime("yyyyMMdd", "dd/MM/yyyy", endTime) ));

			headers.add(new MergedBean(2, 2, 1, 3, "每件单价"));
			headers.add(new MergedBean(2, 2, 4, 6, "销售金额"));
			headers.add(new MergedBean(2, 2, 7, 9, "销售占比"));
			headers.add(new MergedBean(2, 2, 10, 12, "毛利率"));
			headers.add(new MergedBean(2, 2, 13, 15, "库存成本"));


			headers.add(new MergedBean(3, 3, 1, 1, "去年同期每件单价"));
			headers.add(new MergedBean(3, 3, 2, 2, "每件单价"));
			headers.add(new MergedBean(3, 3, 3, 3, "对比"));
			headers.add(new MergedBean(3, 3, 4, 4, "去年同期销售金额"));
			headers.add(new MergedBean(3, 3, 5, 5, "销售金额"));
			headers.add(new MergedBean(3, 3, 6, 6, "对比"));
			headers.add(new MergedBean(3, 3, 7, 7, "去年同期销售占比"));
			headers.add(new MergedBean(3, 3, 8, 8, "销售占比"));
			headers.add(new MergedBean(3, 3, 9, 9, "对比"));
			headers.add(new MergedBean(3, 3, 10, 10, "去年毛利率"));
			headers.add(new MergedBean(3, 3, 11, 11, "毛利率"));
			headers.add(new MergedBean(3, 3, 12, 12, "对比"));
			headers.add(new MergedBean(3, 3, 13, 13, "去年同期库存成本"));
			headers.add(new MergedBean(3, 3, 14, 14, "库存成本"));
			headers.add(new MergedBean(3, 3, 15, 15, "对比"));
		}else if (dateType.equals(Constant.ITEM_SALE_RANK_STRING)) {
			headers.add(new MergedBean(0, 0, 0, 10, SHEET_NAME_ITEM_SALE_RANK));
			headers.add(new MergedBean(1, 3, 0, 0, "款号"));
					

			headers.add(new MergedBean(1, 1, 1, 1, ""));
			headers.add(new MergedBean(1, 1, 2, 2, ""));
			headers.add(new MergedBean(1, 1, 3, 3, ""));
			headers.add(new MergedBean(1, 1, 4, 4, ""));
			headers.add(new MergedBean(1, 1, 5, 10, "本周"+ReportExportUtil.formatTime("yyyyMMdd", "dd/MM/yyyy", beginTime) +"--"+ReportExportUtil.formatTime("yyyyMMdd", "dd/MM/yyyy", endTime) ));
			
			headers.add(new MergedBean(2, 2, 1, 1, "品牌"));
			headers.add(new MergedBean(2, 2, 2, 2, "年份"));
			headers.add(new MergedBean(2, 2, 3, 3, "产品分类"));
			headers.add(new MergedBean(2, 2, 4, 4, "款式类别"));
			headers.add(new MergedBean(2, 2, 5, 7, "销售件数"));
			headers.add(new MergedBean(2, 2, 8, 8, "每件单价"));
			headers.add(new MergedBean(2, 2, 9, 9, "折扣率"));
			headers.add(new MergedBean(2, 2, 10, 10, "毛利率"));

			headers.add(new MergedBean(3, 3, 1, 1, ""));
			headers.add(new MergedBean(3, 3, 2, 2, ""));
			headers.add(new MergedBean(3, 3, 3, 3, ""));
			headers.add(new MergedBean(3, 3, 4, 4, ""));
			headers.add(new MergedBean(3, 3, 5, 5, "上周销售件数"));
			headers.add(new MergedBean(3, 3, 6, 6, "销售件数"));
			headers.add(new MergedBean(3, 3, 7, 7, "对比"));
			headers.add(new MergedBean(3, 3, 8, 8, ""));
			headers.add(new MergedBean(3, 3, 9, 9, ""));
			headers.add(new MergedBean(3, 3, 10, 10, ""));
		}
		return headers;
	}
}
